
CREATE TABLE [dbo].[CashRemittanceToAgent_Log](
	[CRTAID_log] [bigint] NOT NULL,
	[CRTAID] [bigint] NOT NULL,
	[CRTANo] [varchar](50) NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[CreatedBy] [bigint] NOT NULL,
	[ModifyDate] [datetime] NULL,
	[ModifyBy] [bigint] NULL,
	[ReceivedDate] [datetime] NOT NULL,
	[ToAgentID] [bigint] NULL,
	[DefaultBranchID] [bigint] NULL,
	[PaymentCurrencyID] [bigint] NULL,
	[ReceivedCurrencyID] [bigint] NULL,
	[Rate] [decimal](18, 4) NOT NULL,
	[TotalPaymentAmount] [decimal](18, 4) NOT NULL,
	[TotalReceivedAmount] [decimal](18, 4) NOT NULL,
	[ExtraFees] [decimal](18, 4) NOT NULL,
	[NetAmount] [decimal](18, 4) NOT NULL,
	[Payment] [decimal](18, 4) NOT NULL,
	[BankID] [bigint] NULL,
	[log_sysDate] [datetime] NOT NULL,
	[log_userid] [bigint] NOT NULL,
	[log_status] [tinyint] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


